
*******************************************************************************************
*******************************************************************************************
******************** Reclassification Risk in the Small Group Health Insurance Market
******************* by Sebastian Fleitas, Gautam Gowrisankaran and Anthony Lo Sasso 
*******************************************************************************************
*******************************************************************************************
*******************************************************************************************
******************** Figure A1 
*******************************************************************************************
*******************************************************************************************
*******************************************************************************************
  
clear all 
set scheme s2mono

cd "/Users/sebastianfleitas/Dropbox/MULTICHOICE_PROJECT/PREMIUMS_AND_HEALTHSHOCKS/Tables_RESTAT/Do_files_Analysis/Trend_MEPS/"

import excel SGM_takeup_graph.xlsx, clear  firstrow

drop if year<2009

label var Employees_Offered "Employees Offered"
label var Enroll_Offered "Enrollment when Offered"

twoway (line Employees_Offered year) (line Enroll_Offered year), xline(2014,lpattern(dash)) ytitle("Percentage (%)") xtitle("Year") ylab(40(10)85) xlab(2009(1)2019) 
graph export TwoLines_Paper_SGM.png, replace 
